package com.cdtye.itps.cms.mapper.equipment;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.cdtye.itps.cms.dao.equipment.entity.EquipmentDivceAttr;
import com.cdtye.itps.cms.dao.equipment.vo.EquipmentDivceAttrVo;
import com.cdtye.itps.cms.dao.result.DeviceStatisticVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * 设备履历表  包含123456c的属性信息  连接厂家 分类表 对应关系1对1 Mapper 接口
 * @author sup
 * @date 2021-08-17
 */
@Repository
public interface EquipmentDivceAttrMapper extends BaseMapper<EquipmentDivceAttr> {

    /**
     * 分页查询,自定义sql语句
     * @param page
     * @param vo
     * @return
     */
    IPage<Map<String,Object>> list(IPage page, @Param("model") EquipmentDivceAttrVo vo);

    IPage<Map<String, Object>> listByPage(Page page,@Param("model") EquipmentDivceAttrVo vo);

    List<Map<String, Object>> count(@Param("model") EquipmentDivceAttrVo vo);

    List<Map<String, Object>> getAll();

    List<Map<String, Object>> getDivceStatsDtId(String jcjcstate);
}
